﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using FOModels.Company;
namespace DataAccess.Company
{
    public class CompanyDAL
    {
        private SQLDataAccess db;
        public CompanyDAL()
        {
            db = new SQLDataAccess();
        }
        public DataTable getPartnerList(int langid)
        {
            return db.exeSelect("select c.CompanyID,c.CompanyLogo,c.Website,c.Phone,c.Active,c.ActiveHome,cl.Name,cl.[Address]  from Company c join CompanyLang cl on c.CompanyID = cl.CompanyID where c.Active = 1 and c.ActiveHome = 1 and LangID = " + langid + "");
        }
        public DataTable getCompany(int langid)
        {
            return db.exeSelect("select c.CompanyID,c.CompanyLogo,c.Website,c.Phone,c.Active,c.ActiveHome,cl.Name,cl.[Address],l.FlagImage  from Company c join CompanyLang cl on c.CompanyID = cl.CompanyID join [Language] l on cl.LangID = l.ID where LangID=" + langid + "");
        }
        public DataTable getTOP1Company()
        {
            return db.exeSelect("select top 1 * from Company order by CompanyID desc");
        }
        public DataTable getTableTermInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableTermInterest where CompanyID = " + CompanyID + " order by Month asc");
        }
        public DataTable getTableHomeLoanEquityInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableHomeLoanEquityInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableHomeLoanMortgageInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableHomeLoanMortgageInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableCarLoanEquityInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableCarLoanEquityInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableCarLoanMortgageInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableCarLoanMortgageInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableTermDemandInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableTermDemandInterest where CompanyID = " + CompanyID + " order by Month asc");
        }
        public DataTable getCompanybyID(int CompanyID, int langid)
        {
            return db.exeSelect("Select * from Company c join CompanyLang cl on c.CompanyID = cl.CompanyID where LangID = " + langid + " and cl.CompanyID = " + CompanyID + "");
        }
        public int InsertCompanyLang(CompanyModels models, int langid)
        {
            return db.exeUpdate("insert into CompanyLang values (" + models.CompanyID + "," + langid + ",N'" + models.Name + "',N'" + models.Address + "')");
        }
        public int InsertCompany(CompanyModels models)
        {
            return db.exeUpdate("insert into Company values (N'" + models.CompanyLogo + "',N'" + models.Website + "',N'" + models.Phone + "','" + models.Active + "','" + models.ActiveHome + "')");
        }
        public int DeleteCompanyLang(int CompanyID)
        {
            return db.exeUpdate("Delete from CompanyLang where CompanyID = " + CompanyID + "");
        }
        public int DeleteCompany(int CompanyID)
        {
            return db.exeUpdate("Delete from Company where CompanyID = " + CompanyID + "");
        }
        public int UpdateCompanyLang(CompanyModels models, int langid)
        {
            return db.exeUpdate("update CompanyLang set Name = N'" + models.Name + "',Address= N'" + models.Address + "' where CompanyID = " + models.CompanyID + " and LangID=" + langid + "");
        }
        public int UpdateCompany(CompanyModels models)
        {
            return db.exeUpdate("update Company set  Phone=N'" + models.Phone + "',CompanyLogo=N'" + models.CompanyLogo + "',Website='" + models.Website + "',Active = '" + models.Active + "',ActiveHome='" + models.ActiveHome + "' where CompanyID = " + models.CompanyID + "");
        }
        public int InsertTableTermInterest(TableTermInterestModels models)
        {
            return db.exeUpdate("insert into TableTermInterest values (" + models.Month + "," + models.InterestVND + "," + models.InterestEUR + "," + models.InterestUSD + "," + models.CompanyID + ")");
        }
        public int InsertTableHomeLoanMortgageInterest(TableHomeLoanMortgageInterestModels models)
        {
            return db.exeUpdate("insert into TableHomeLoanMortgageInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int InsertTableHomeLoanEquityInterest(TableHomeLoanEquityInterestModels models)
        {
            return db.exeUpdate("insert into TableHomeLoanEquityInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int InsertTableCarLoanEquityInterest(TableCarLoanEquityInterestModels models)
        {
            return db.exeUpdate("insert into TableCarLoanEquityInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int InsertTableCarLoanMortgageInterest(TableHomeCarMortgageInterestModels models)
        {
            return db.exeUpdate("insert into TableCarLoanMortgageInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int InsertTableDemandTermInterest(TableTermDemandInterest models)
        {
            return db.exeUpdate("insert into TableTermDemandInterest values (" + models.Month + "," + models.InterestVND + "," + models.InterestEUR + "," + models.InterestUSD + "," + models.CompanyID + ")");
        }
        public int UpdateTableTermDemandInterest(TableTermDemandInterest models)
        {
            return db.exeUpdate("update TableTermDemandInterest set Month = " + models.Month + ",InterestVND = " + models.InterestVND + ",InterestEUR = " + models.InterestEUR + ", InterestUSD = " + models.InterestUSD + " where TableTermDemandInterestID = " + models.TableTermDemandInterestID + "");
        }
        public int UpdateTableHomeLoanEquityInterest(TableHomeLoanEquityInterestModels models)
        {
            return db.exeUpdate("update TableHomeLoanEquityInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableHomeLoanEquityInterestID = " + models.TableHomeLoanEquityInterestID + "");
        }
        public int UpdateTableHomeLoanMortgageInterest(TableHomeLoanMortgageInterestModels models)
        {
            return db.exeUpdate("update TableHomeLoanMortgageInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableHomeLoanMortgageInterestID = " + models.TableHomeLoanMortgageInterestID + "");
        }
        public int UpdateTableCarLoanMortgageInterest(TableHomeCarMortgageInterestModels models)
        {
            return db.exeUpdate("update TableCarLoanMortgageInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableCarLoanMortgageInterestID = " + models.TableCarLoanMortgageInterestID + "");
        }
        public int UpdateTableCarLoanEquityInterest(TableCarLoanEquityInterestModels models)
        {
            return db.exeUpdate("update TableCarLoanEquityInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableCarLoanEquityInterestID = " + models.TableCarLoanEquityInterestID + "");
        }
        public int UpdateTableTermInterest(TableTermInterestModels models)
        {
            return db.exeUpdate("update TableTermInterest set Month = " + models.Month + ",InterestVND = " + models.InterestVND + ",InterestEUR = " + models.InterestEUR + ", InterestUSD = " + models.InterestUSD + " where TableTermInterestID = " + models.TableTermInterestID + "");
        }
        public int DeleteTableTermInterest(int TableTermInterestID)
        {
            return db.exeUpdate("Delete from TableTermInterest where TableTermInterestID = " + TableTermInterestID + "");
        }
        public int DeleteTableTermDemandInterest(int TableTermDemandInterestID)
        {
            return db.exeUpdate("Delete from TableTermDemandInterest where TableTermDemandInterestID = " + TableTermDemandInterestID + "");
        }
        public int DeleteTableHomeLoanEquityInterest(int TableHomeLoanEquityInterestID)
        {
            return db.exeUpdate("Delete from TableHomeLoanEquityInterest where TableHomeLoanEquityInterestID = " + TableHomeLoanEquityInterestID + "");
        }
        public int DeleteTableHomeLoanMortgageInterest(int TableHomeLoanMortgageInterestID)
        {
            return db.exeUpdate("Delete from TableHomeLoanMortgageInterest where TableHomeLoanMortgageInterestID = " + TableHomeLoanMortgageInterestID + "");
        }
        public int DeleteTableCarLoanEquityInterest(int TableCarLoanEquityInterestID)
        {
            return db.exeUpdate("Delete from TableCarLoanEquityInterest where TableCarLoanEquityInterestID = " + TableCarLoanEquityInterestID + "");
        }
        public int DeleteTableCarLoanMortgageInterest(int TableCarLoanMortgageInterestID)
        {
            return db.exeUpdate("Delete from TableCarLoanMortgageInterest where TableCarLoanMortgageInterestID = " + TableCarLoanMortgageInterestID + "");
        }
        public DataTable getTermDemandInterestID(int TableTermDemandInterestID)
        {
            return db.exeSelect("Select * from TableTermDemandInterest where TableTermDemandInterestID = " + TableTermDemandInterestID + "");
        }
        public DataTable getTableHomeLoanEquityInterestID(int TableHomeLoanEquityInterestID)
        {
            return db.exeSelect("Select * from TableHomeLoanEquityInterest where TableHomeLoanEquityInterestID = " + TableHomeLoanEquityInterestID + "");
        }
        public DataTable getTermInterestID(int TableTermInterestID)
        {
            return db.exeSelect("Select * from TableTermInterest where TableTermInterestID = " + TableTermInterestID + "");
        }
        public DataTable getTableHomeLoanMortgageInterestID(int TableHomeLoanMortgageInterestID)
        {
            return db.exeSelect("Select * from TableHomeLoanMortgageInterest where TableHomeLoanMortgageInterestID = " + TableHomeLoanMortgageInterestID + "");
        }
        public DataTable getTableCarLoanEquityInterestID(int TableCarLoanEquityInterestID)
        {
            return db.exeSelect("Select * from TableCarLoanEquityInterest where TableCarLoanEquityInterestID = " + TableCarLoanEquityInterestID + "");
        }
        public DataTable getTableCarLoanMortgageInterestID(int TableCarLoanMortgageInterestID)
        {
            return db.exeSelect("Select * from TableCarLoanMortgageInterest where TableCarLoanMortgageInterestID = " + TableCarLoanMortgageInterestID + "");
        }

        ///SHORT TERM LOAN

        public DataTable getTableShortTermLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableShortTermLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableShortTermLoanInterestID(int TableShortTermLoanInterestID)
        {
            return db.exeSelect("Select * from TableShortTermLoanInterest where TableShortTermLoanInterestID = " + TableShortTermLoanInterestID + "");
        }
        public int InsertTableShortTermLoanInterest(TableShortTermLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableShortTermLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableShortTermLoanInterest(TableShortTermLoanInterestModels models)
        {
            return db.exeUpdate("update TableShortTermLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableShortTermLoanInterestID = " + models.TableShortTermLoanInterestID + "");
        }
        public int DeleteTableShortTermLoanInterest(int TableShortTermLoanInterestID)
        {
            return db.exeUpdate("Delete from TableShortTermLoanInterest where TableShortTermLoanInterestID = " + TableShortTermLoanInterestID + "");
        }

        ///LONG TERM LOAN

        public DataTable getTableLongTermLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableLongTermLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableLongTermLoanInterestID(int TableLongTermLoanInterestID)
        {
            return db.exeSelect("Select * from TableLongTermLoanInterest where TableLongTermLoanInterestID = " + TableLongTermLoanInterestID + "");
        }
        public int InsertTableLongTermLoanInterest(TableLongTermLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableLongTermLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableLongTermLoanInterest(TableLongTermLoanInterestModels models)
        {
            return db.exeUpdate("update TableLongTermLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableLongTermLoanInterestID = " + models.TableLongTermLoanInterestID + "");
        }
        public int DeleteTableLongTermLoanInterest(int TableLongTermLoanInterestID)
        {
            return db.exeUpdate("Delete from TableLongTermLoanInterest where TableLongTermLoanInterestID = " + TableLongTermLoanInterestID + "");
        }

        ///CAPITAL LOAN
        ///

        public DataTable getTableCapitalLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableCapitalLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableCapitalLoanInterestID(int TableCapitalLoanInterestID)
        {
            return db.exeSelect("Select * from TableCapitalLoanInterest where TableCapitalLoanInterestID = " + TableCapitalLoanInterestID + "");
        }
        public int InsertTableCapitalLoanInterest(TableCapitalLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableCapitalLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableCapitalLoanInterest(TableCapitalLoanInterestModels models)
        {
            return db.exeUpdate("update TableCapitalLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableCapitalLoanInterestID = " + models.TableCapitalLoanInterestID + "");
        }
        public int DeleteTableCapitalLoanInterest(int TableCapitalLoanInterestID)
        {
            return db.exeUpdate("Delete from TableCapitalLoanInterest where TableCapitalLoanInterestID = " + TableCapitalLoanInterestID + "");
        }
 
        ///
        ///FINACIAL LOAN
        public DataTable getTableFinancialLeasingLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableFinancialLeasingLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableFinancialLeasingLoanInterestID(int TableFinancialLeasingLoanInterestID)
        {
            return db.exeSelect("Select * from TableFinancialLeasingLoanInterest where TableFinancialLeasingLoanInterestID = " + TableFinancialLeasingLoanInterestID + "");
        }
        public int InsertTableFinancialLeasingLoanInterest(TableFinancialLeasingLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableFinancialLeasingLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableFinancialLeasingLoanInterest(TableFinancialLeasingLoanInterestModels models)
        {
            return db.exeUpdate("update TableFinancialLeasingLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableFinancialLeasingLoanInterestID = " + models.TableFinancialLeasingLoanInterestID + "");
        }
        public int DeleteTableFinancialLeasingLoanInterest(int TableFinancialLeasingLoanInterestID)
        {
            return db.exeUpdate("Delete from TableFinancialLeasingLoanInterest where TableFinancialLeasingLoanInterestID = " + TableFinancialLeasingLoanInterestID + "");
        }


        //ConsumerLoan

        public DataTable getTableConsumerLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableConsumerLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableConsumerLoanInterestID(int TableConsumerLoanInterestID)
        {
            return db.exeSelect("Select * from TableConsumerLoanInterest where TableConsumerLoanInterestID = " + TableConsumerLoanInterestID + "");
        }
        public int InsertTableConsumerLoanInterest(TableConsumerLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableConsumerLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableConsumerLoanInterest(TableConsumerLoanInterestModels models)
        {
            return db.exeUpdate("update TableConsumerLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableConsumerLoanInterestID = " + models.TableConsumerLoanInterestID + "");
        }
        public int DeleteTableConsumerLoanInterest(int TableConsumerLoanInterestID)
        {
            return db.exeUpdate("Delete from TableConsumerLoanInterest where TableConsumerLoanInterestID = " + TableConsumerLoanInterestID + "");
        }


        //EducationLoan

        public DataTable getTableEducationLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableEducationLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableEducationLoanInterestID(int TableEducationLoanInterestID)
        {
            return db.exeSelect("Select * from TableEducationLoanInterest where TableEducationLoanInterestID = " + TableEducationLoanInterestID + "");
        }
        public int InsertTableEducationLoanInterest(TableEducationLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableEducationLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableEducationLoanInterest(TableEducationLoanInterestModels models)
        {
            return db.exeUpdate("update TableEducationLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableEducationLoanInterestID = " + models.TableEducationLoanInterestID + "");
        }
        public int DeleteTableEducationLoanInterest(int TableEducationLoanInterestID)
        {
            return db.exeUpdate("Delete from TableEducationLoanInterest where TableEducationLoanInterestID = " + TableEducationLoanInterestID + "");
        }

        //OverdraftLoan

        public DataTable getTableOverdraftLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableOverdraftLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableOverdraftLoanInterestID(int TableOverdraftLoanInterestID)
        {
            return db.exeSelect("Select * from TableOverdraftLoanInterest where TableOverdraftLoanInterestID = " + TableOverdraftLoanInterestID + "");
        }
        public int InsertTableOverdraftLoanInterest(TableOverdraftLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableOverdraftLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableOverdraftLoanInterest(TableOverdraftLoanInterestModels models)
        {
            return db.exeUpdate("update TableOverdraftLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableOverdraftLoanInterestID = " + models.TableOverdraftLoanInterestID + "");
        }
        public int DeleteTableOverdraftLoanInterest(int TableOverdraftLoanInterestID)
        {
            return db.exeUpdate("Delete from TableOverdraftLoanInterest where TableOverdraftLoanInterestID = " + TableOverdraftLoanInterestID + "");
        }

        //ConsumerInstallmentLoan

        public DataTable getTableConsumerInstallmentLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableConsumerInstallmentLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableConsumerInstallmentLoanInterestID(int TableConsumerInstallmentLoanInterestID)
        {
            return db.exeSelect("Select * from TableConsumerInstallmentLoanInterest where TableConsumerInstallmentLoanInterestID = " + TableConsumerInstallmentLoanInterestID + "");
        }
        public int InsertTableConsumerInstallmentLoanInterest(TableConsumerInstallmentLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableConsumerInstallmentLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableConsumerInstallmentLoanInterest(TableConsumerInstallmentLoanInterestModels models)
        {
            return db.exeUpdate("update TableConsumerInstallmentLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableConsumerInstallmentLoanInterestID = " + models.TableConsumerInstallmentLoanInterestID + "");
        }
        public int DeleteTableConsumerInstallmentLoanInterest(int TableConsumerInstallmentLoanInterestID)
        {
            return db.exeUpdate("Delete from TableConsumerInstallmentLoanInterest where TableConsumerInstallmentLoanInterestID = " + TableConsumerInstallmentLoanInterestID + "");
        }

        //PersonalBusinessLoan

        public DataTable getTablePersonalBusinessLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TablePersonalBusinessLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTablePersonalBusinessLoanInterestID(int TablePersonalBusinessLoanInterestID)
        {
            return db.exeSelect("Select * from TablePersonalBusinessLoanInterest where TablePersonalBusinessLoanInterestID = " + TablePersonalBusinessLoanInterestID + "");
        }
        public int InsertTablePersonalBusinessLoanInterest(TablePersonalBusinessLoanInterestModels models)
        {
            return db.exeUpdate("insert into TablePersonalBusinessLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTablePersonalBusinessLoanInterest(TablePersonalBusinessLoanInterestModels models)
        {
            return db.exeUpdate("update TablePersonalBusinessLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TablePersonalBusinessLoanInterestID = " + models.TablePersonalBusinessLoanInterestID + "");
        }
        public int DeleteTablePersonalBusinessLoanInterest(int TablePersonalBusinessLoanInterestID)
        {
            return db.exeUpdate("Delete from TablePersonalBusinessLoanInterest where TablePersonalBusinessLoanInterestID = " + TablePersonalBusinessLoanInterestID + "");
        }


        //HomeEquityLoan

        public DataTable getTableHomeEquityLoanInterestbyComID(int CompanyID)
        {
            return db.exeSelect("Select * from TableHomeEquityLoanInterest where CompanyID = " + CompanyID + " order by Years asc");
        }
        public DataTable getTableHomeEquityLoanInterestID(int TableHomeEquityLoanInterestID)
        {
            return db.exeSelect("Select * from TableHomeEquityLoanInterest where TableHomeEquityLoanInterestID = " + TableHomeEquityLoanInterestID + "");
        }
        public int InsertTableHomeEquityLoanInterest(TableHomeEquityLoanInterestModels models)
        {
            return db.exeUpdate("insert into TableHomeEquityLoanInterest values (" + models.Years + "," + models.InterestVND + "," + models.CompanyID + ")");
        }
        public int UpdateTableHomeEquityLoanInterest(TableHomeEquityLoanInterestModels models)
        {
            return db.exeUpdate("update TableHomeEquityLoanInterest set Years = " + models.Years + ",InterestVND = " + models.InterestVND + " where TableHomeEquityLoanInterestID = " + models.TableHomeEquityLoanInterestID + "");
        }
        public int DeleteTableHomeEquityLoanInterest(int TableHomeEquityLoanInterestID)
        {
            return db.exeUpdate("Delete from TableHomeEquityLoanInterest where TableHomeEquityLoanInterestID = " + TableHomeEquityLoanInterestID + "");
        }

    }
}
